Dataset statistics
| Number of variables | 31 |
|---|---|
| Number of observations | 199551 |
| Missing cells | 348463 |
| Missing cells (%) | 5.6% |
| Duplicate rows | 2 |
| Duplicate rows (%) | < 0.1% |
| Total size in memory | 38.1 MiB |
| Average record size in memory | 200.0 B |
Variable types
| Categorical | 8 |
|---|---|
| DateTime | 5 |
| Numeric | 10 |
| Boolean | 8 |
| Dataset has 2 (< 0.1%) duplicate rows | Duplicates |
Valor del Contrato is highly overall correlated with Saldo CDP | High correlation |
Valor Facturado is highly overall correlated with Valor Pendiente de Pago and 2 other fields | High correlation |
Valor Pendiente de Pago is highly overall correlated with Valor Facturado and 2 other fields | High correlation |
Valor Pagado is highly overall correlated with Valor Facturado and 2 other fields | High correlation |
Valor Pendiente de Ejecucion is highly overall correlated with Valor Facturado and 2 other fields | High correlation |
Saldo CDP is highly overall correlated with Valor del Contrato | High correlation |
Modalidad de Contratacion is highly overall correlated with EsPrestacionServicios and 1 other fields | High correlation |
EsPrestacionServicios is highly overall correlated with Modalidad de Contratacion | High correlation |
EsPyme is highly overall correlated with Modalidad de Contratacion | High correlation |
Rama is highly imbalanced (64.5%) | Imbalance |
Modalidad de Contratacion is highly imbalanced (67.7%) | Imbalance |
EsGrupo is highly imbalanced (94.5%) | Imbalance |
EsObligacionAmbiental is highly imbalanced (76.4%) | Imbalance |
Es PostConflicto is highly imbalanced (95.6%) | Imbalance |
Fecha de Inicio de Ejecucion has 174156 (87.3%) missing values | Missing |
Fecha de Fin de Ejecucion has 173961 (87.2%) missing values | Missing |
Valor del Contrato is highly skewed (γ1 = 397.1971247) | Skewed |
Valor Facturado is highly skewed (γ1 = 439.6718332) | Skewed |
Valor Pendiente de Pago is highly skewed (γ1 = 228.5471793) | Skewed |
Valor Pagado is highly skewed (γ1 = 439.3312176) | Skewed |
Valor Pendiente de Ejecucion is highly skewed (γ1 = 122.4992687) | Skewed |
Saldo CDP is highly skewed (γ1 = 220.0639176) | Skewed |
Dias Adicionados is highly skewed (γ1 = 35.4033165) | Skewed |
Presupuesto General de la Nacion – PGN is highly skewed (γ1 = 437.9613202) | Skewed |
Recursos Propios (AlcaldÃas, Gobernaciones y Resguardos IndÃgenas) is highly skewed (γ1 = 169.3895246) | Skewed |
Recursos Propios is highly skewed (γ1 = 149.500941) | Skewed |
Valor Facturado has 82836 (41.5%) zeros | Zeros |
Valor Pendiente de Pago has 73431 (36.8%) zeros | Zeros |
Valor Pagado has 93285 (46.7%) zeros | Zeros |
Valor Pendiente de Ejecucion has 73005 (36.6%) zeros | Zeros |
Saldo CDP has 10520 (5.3%) zeros | Zeros |
Dias Adicionados has 198518 (99.5%) zeros | Zeros |
Presupuesto General de la Nacion – PGN has 161214 (80.8%) zeros | Zeros |
Recursos Propios (AlcaldÃas, Gobernaciones y Resguardos IndÃgenas) has 110760 (55.5%) zeros | Zeros |
Recursos Propios has 165174 (82.8%) zeros | Zeros |
Reproduction
| Analysis started | 2023-07-20 00:24:44.276290 |
|---|---|
| Analysis finished | 2023-07-20 00:25:32.886275 |
| Duration | 48.61 seconds |
| Software version | ydata-profiling vv4.2.0 |
| Download configuration | config.json |
Departamento
Categorical
| Distinct | 34 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| Distrito Capital de Bogotá | |
|---|---|
| Valle del Cauca | |
| Antioquia | |
| Santander | |
| Meta | |
| Other values (29) |
Length
| Max length | 40 |
|---|---|
| Median length | 26 |
| Mean length | 14.434571 |
| Min length | 4 |
Characters and Unicode
| Total characters | 2880433 |
|---|---|
| Distinct characters | 45 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Antioquia |
|---|---|
| 2nd row | Distrito Capital de Bogotá |
| 3rd row | Santander |
| 4th row | Boyacá |
| 5th row | Antioquia |
Common Values
| Value | Count | Frequency (%) |
| Distrito Capital de Bogotá | 58836 | |
| Valle del Cauca | 23048 | 11.5% |
| Antioquia | 19788 | 9.9% |
| Santander | 14842 | 7.4% |
| Meta | 9185 | 4.6% |
| Boyacá | 8682 | 4.4% |
| Risaralda | 6715 | 3.4% |
| Cundinamarca | 6606 | 3.3% |
| Huila | 5990 | 3.0% |
| Casanare | 5618 | 2.8% |
| Other values (24) | 40241 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| de | 63810 | |
| distrito | 58836 | |
| capital | 58836 | |
| bogotá | 58836 | |
| cauca | 25583 | 5.8% |
| valle | 23048 | 5.2% |
| del | 23048 | 5.2% |
| santander | 19816 | 4.5% |
| antioquia | 19788 | 4.5% |
| meta | 9185 | 2.1% |
| Other values (35) | 81573 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 377058 | |
| t | 301182 | 10.5% |
| i | 255774 | 8.9% |
| 242808 | 8.4% | |
| o | 231785 | 8.0% |
| l | 159014 | 5.5% |
| e | 158162 | 5.5% |
| d | 133791 | 4.6% |
| r | 117918 | 4.1% |
| C | 106494 | 3.7% |
| Other values (35) | 796447 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2282124 | |
| Uppercase Letter | 353678 | 12.3% |
| Space Separator | 242808 | 8.4% |
| Other Punctuation | 1823 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 377058 | |
| t | 301182 | |
| i | 255774 | |
| o | 231785 | |
| l | 159014 | |
| e | 158162 | |
| d | 133791 | 5.9% |
| r | 117918 | 5.2% |
| n | 96990 | 4.2% |
| s | 78955 | 3.5% |
| Other values (18) | 371495 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 106494 | |
| B | 71563 | |
| D | 59593 | |
| A | 26843 | 7.6% |
| S | 24041 | 6.8% |
| V | 23304 | 6.6% |
| M | 10960 | 3.1% |
| N | 7541 | 2.1% |
| R | 6715 | 1.9% |
| H | 5990 | 1.7% |
| Other values (5) | 10634 | 3.0% |
Space Separator
| Value | Count | Frequency (%) |
| 242808 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 1823 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2635802 | |
| Common | 244631 | 8.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 377058 | |
| t | 301182 | |
| i | 255774 | 9.7% |
| o | 231785 | 8.8% |
| l | 159014 | 6.0% |
| e | 158162 | 6.0% |
| d | 133791 | 5.1% |
| r | 117918 | 4.5% |
| C | 106494 | 4.0% |
| n | 96990 | 3.7% |
| Other values (33) | 697634 |
Common
| Value | Count | Frequency (%) |
| 242808 | ||
| , | 1823 | 0.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2795801 | |
| None | 84632 | 2.9% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 377058 | |
| t | 301182 | |
| i | 255774 | 9.1% |
| 242808 | 8.7% | |
| o | 231785 | 8.3% |
| l | 159014 | 5.7% |
| e | 158162 | 5.7% |
| d | 133791 | 4.8% |
| r | 117918 | 4.2% |
| C | 106494 | 3.8% |
| Other values (30) | 711815 |
None
| Value | Count | Frequency (%) |
| á | 72117 | |
| Ã | 7426 | 8.8% |
| é | 1962 | 2.3% |
| ñ | 1810 | 2.1% |
| ó | 1317 | 1.6% |
Orden
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| Territorial | |
|---|---|
| Nacional | |
| Corporación Autónoma | 3258 |
Length
| Max length | 20 |
|---|---|
| Median length | 11 |
| Mean length | 10.091946 |
| Min length | 8 |
Characters and Unicode
| Total characters | 2013858 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Nacional |
|---|---|
| 2nd row | Nacional |
| 3rd row | Corporación Autónoma |
| 4th row | Territorial |
| 5th row | Territorial |
Common Values
| Value | Count | Frequency (%) |
| Territorial | 126118 | |
| Nacional | 70175 | |
| Corporación Autónoma | 3258 | 1.6% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| territorial | 126118 | |
| nacional | 70175 | |
| corporación | 3258 | 1.6% |
| autónoma | 3258 | 1.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 384870 | |
| i | 325669 | |
| a | 272984 | |
| o | 206067 | |
| l | 196293 | |
| t | 129376 | 6.4% |
| T | 126118 | 6.3% |
| e | 126118 | 6.3% |
| n | 76691 | 3.8% |
| c | 73433 | 3.6% |
| Other values (8) | 96239 | 4.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1807791 | |
| Uppercase Letter | 202809 | 10.1% |
| Space Separator | 3258 | 0.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 384870 | |
| i | 325669 | |
| a | 272984 | |
| o | 206067 | |
| l | 196293 | |
| t | 129376 | 7.2% |
| e | 126118 | 7.0% |
| n | 76691 | 4.2% |
| c | 73433 | 4.1% |
| ó | 6516 | 0.4% |
| Other values (3) | 9774 | 0.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 126118 | |
| N | 70175 | |
| C | 3258 | 1.6% |
| A | 3258 | 1.6% |
Space Separator
| Value | Count | Frequency (%) |
| 3258 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2010600 | |
| Common | 3258 | 0.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 384870 | |
| i | 325669 | |
| a | 272984 | |
| o | 206067 | |
| l | 196293 | |
| t | 129376 | 6.4% |
| T | 126118 | 6.3% |
| e | 126118 | 6.3% |
| n | 76691 | 3.8% |
| c | 73433 | 3.7% |
| Other values (7) | 92981 | 4.6% |
Common
| Value | Count | Frequency (%) |
| 3258 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2007342 | |
| None | 6516 | 0.3% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 384870 | |
| i | 325669 | |
| a | 272984 | |
| o | 206067 | |
| l | 196293 | |
| t | 129376 | 6.4% |
| T | 126118 | 6.3% |
| e | 126118 | 6.3% |
| n | 76691 | 3.8% |
| c | 73433 | 3.7% |
| Other values (7) | 89723 | 4.5% |
None
| Value | Count | Frequency (%) |
| ó | 6516 |
Rama
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| Ejecutivo | |
|---|---|
| Corporación Autónoma | |
| Judicial | 1784 |
| Legislativo | 1588 |
Length
| Max length | 20 |
|---|---|
| Median length | 9 |
| Mean length | 10.502097 |
| Min length | 8 |
Characters and Unicode
| Total characters | 2095704 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Corporación Autónoma |
|---|---|
| 2nd row | Ejecutivo |
| 3rd row | Corporación Autónoma |
| 4th row | Ejecutivo |
| 5th row | Ejecutivo |
Common Values
| Value | Count | Frequency (%) |
| Ejecutivo | 169056 | |
| Corporación Autónoma | 27123 | 13.6% |
| Judicial | 1784 | 0.9% |
| Legislativo | 1588 | 0.8% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| ejecutivo | 169056 | |
| corporación | 27123 | 12.0% |
| autónoma | 27123 | 12.0% |
| judicial | 1784 | 0.8% |
| legislativo | 1588 | 0.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 252013 | |
| i | 202923 | |
| c | 197963 | |
| u | 197963 | |
| t | 197767 | |
| e | 170644 | |
| v | 170644 | |
| E | 169056 | |
| j | 169056 | |
| a | 57618 | 2.7% |
| Other values (14) | 310057 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1841907 | |
| Uppercase Letter | 226674 | 10.8% |
| Space Separator | 27123 | 1.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 252013 | |
| i | 202923 | |
| c | 197963 | |
| u | 197963 | |
| t | 197767 | |
| e | 170644 | |
| v | 170644 | |
| j | 169056 | |
| a | 57618 | 3.1% |
| r | 54246 | 2.9% |
| Other values (8) | 171070 |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 169056 | |
| C | 27123 | 12.0% |
| A | 27123 | 12.0% |
| J | 1784 | 0.8% |
| L | 1588 | 0.7% |
Space Separator
| Value | Count | Frequency (%) |
| 27123 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2068581 | |
| Common | 27123 | 1.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 252013 | |
| i | 202923 | |
| c | 197963 | |
| u | 197963 | |
| t | 197767 | |
| e | 170644 | |
| v | 170644 | |
| E | 169056 | |
| j | 169056 | |
| a | 57618 | 2.8% |
| Other values (13) | 282934 |
Common
| Value | Count | Frequency (%) |
| 27123 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2041458 | |
| None | 54246 | 2.6% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 252013 | |
| i | 202923 | |
| c | 197963 | |
| u | 197963 | |
| t | 197767 | |
| e | 170644 | |
| v | 170644 | |
| E | 169056 | |
| j | 169056 | |
| a | 57618 | 2.8% |
| Other values (13) | 255811 |
None
| Value | Count | Frequency (%) |
| ó | 54246 |
Entidad Centralizada
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| Descentralizada | |
|---|---|
| Centralizada | |
| No Definido | 8234 |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 13.534124 |
| Min length | 11 |
Characters and Unicode
| Total characters | 2700748 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Centralizada |
|---|---|
| 2nd row | Centralizada |
| 3rd row | Centralizada |
| 4th row | Descentralizada |
| 5th row | Descentralizada |
Common Values
| Value | Count | Frequency (%) |
| Descentralizada | 104790 | |
| Centralizada | 86527 | |
| No Definido | 8234 | 4.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| descentralizada | 104790 | |
| centralizada | 86527 | |
| no | 8234 | 4.0% |
| definido | 8234 | 4.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 573951 | |
| e | 304341 | |
| i | 207785 | 7.7% |
| d | 199551 | 7.4% |
| n | 199551 | 7.4% |
| l | 191317 | 7.1% |
| z | 191317 | 7.1% |
| t | 191317 | 7.1% |
| r | 191317 | 7.1% |
| D | 113024 | 4.2% |
| Other values (7) | 337277 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2484729 | |
| Uppercase Letter | 207785 | 7.7% |
| Space Separator | 8234 | 0.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 573951 | |
| e | 304341 | |
| i | 207785 | 8.4% |
| d | 199551 | 8.0% |
| n | 199551 | 8.0% |
| l | 191317 | 7.7% |
| z | 191317 | 7.7% |
| t | 191317 | 7.7% |
| r | 191317 | 7.7% |
| c | 104790 | 4.2% |
| Other values (3) | 129492 | 5.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 113024 | |
| C | 86527 | |
| N | 8234 | 4.0% |
Space Separator
| Value | Count | Frequency (%) |
| 8234 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2692514 | |
| Common | 8234 | 0.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 573951 | |
| e | 304341 | |
| i | 207785 | 7.7% |
| d | 199551 | 7.4% |
| n | 199551 | 7.4% |
| l | 191317 | 7.1% |
| z | 191317 | 7.1% |
| t | 191317 | 7.1% |
| r | 191317 | 7.1% |
| D | 113024 | 4.2% |
| Other values (6) | 329043 |
Common
| Value | Count | Frequency (%) |
| 8234 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2700748 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 573951 | |
| e | 304341 | |
| i | 207785 | 7.7% |
| d | 199551 | 7.4% |
| n | 199551 | 7.4% |
| l | 191317 | 7.1% |
| z | 191317 | 7.1% |
| t | 191317 | 7.1% |
| r | 191317 | 7.1% |
| D | 113024 | 4.2% |
| Other values (7) | 337277 |
Estado Contrato
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| terminado | |
|---|---|
| Cerrado | |
| cedido | 7404 |
| Suspendido | 1269 |
Length
| Max length | 10 |
|---|---|
| Median length | 9 |
| Mean length | 8.2352281 |
| Min length | 6 |
Characters and Unicode
| Total characters | 1643348 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Cerrado |
|---|---|
| 2nd row | cedido |
| 3rd row | Cerrado |
| 4th row | terminado |
| 5th row | terminado |
Common Values
| Value | Count | Frequency (%) |
| terminado | 125044 | |
| Cerrado | 65834 | |
| cedido | 7404 | 3.7% |
| Suspendido | 1269 | 0.6% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| terminado | 125044 | |
| cerrado | 65834 | |
| cedido | 7404 | 3.7% |
| suspendido | 1269 | 0.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 256712 | |
| d | 208224 | |
| e | 199551 | |
| o | 199551 | |
| a | 190878 | |
| i | 133717 | |
| n | 126313 | |
| t | 125044 | |
| m | 125044 | |
| C | 65834 | 4.0% |
| Other values (5) | 12480 | 0.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1576245 | |
| Uppercase Letter | 67103 | 4.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 256712 | |
| d | 208224 | |
| e | 199551 | |
| o | 199551 | |
| a | 190878 | |
| i | 133717 | |
| n | 126313 | |
| t | 125044 | |
| m | 125044 | |
| c | 7404 | 0.5% |
| Other values (3) | 3807 | 0.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 65834 | |
| S | 1269 | 1.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1643348 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 256712 | |
| d | 208224 | |
| e | 199551 | |
| o | 199551 | |
| a | 190878 | |
| i | 133717 | |
| n | 126313 | |
| t | 125044 | |
| m | 125044 | |
| C | 65834 | 4.0% |
| Other values (5) | 12480 | 0.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1643348 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 256712 | |
| d | 208224 | |
| e | 199551 | |
| o | 199551 | |
| a | 190878 | |
| i | 133717 | |
| n | 126313 | |
| t | 125044 | |
| m | 125044 | |
| C | 65834 | 4.0% |
| Other values (5) | 12480 | 0.8% |
Modalidad de Contratacion
Categorical
HIGH CORRELATION IMBALANCE
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| Contratación directa | |
|---|---|
| Contratación régimen especial | |
| MÃnima cuantÃa | |
| Selección Abreviada de Menor CuantÃa | 2506 |
| Selección abreviada subasta inversa | 2454 |
| Other values (10) | 5174 |
Length
| Max length | 59 |
|---|---|
| Median length | 20 |
| Mean length | 21.130152 |
| Min length | 11 |
Characters and Unicode
| Total characters | 4216543 |
|---|---|
| Distinct characters | 42 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Contratación directa |
|---|---|
| 2nd row | Contratación régimen especial |
| 3rd row | Contratación directa |
| 4th row | Contratación directa |
| 5th row | Contratación directa |
Common Values
| Value | Count | Frequency (%) |
| Contratación directa | 153859 | |
| Contratación régimen especial | 19586 | 9.8% |
| MÃnima cuantÃa | 15972 | 8.0% |
| Selección Abreviada de Menor CuantÃa | 2506 | 1.3% |
| Selección abreviada subasta inversa | 2454 | 1.2% |
| Contratación Directa (con ofertas) | 2231 | 1.1% |
| Contratación régimen especial (con ofertas) | 1263 | 0.6% |
| Licitación pública | 545 | 0.3% |
| No Definido | 312 | 0.2% |
| Licitación pública Obra Publica | 306 | 0.2% |
| Other values (5) | 517 | 0.3% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| contratación | 176939 | |
| directa | 156090 | |
| régimen | 20849 | 4.7% |
| especial | 20849 | 4.7% |
| cuantÃa | 18478 | 4.2% |
| mÃnima | 15972 | 3.6% |
| abreviada | 5010 | 1.1% |
| selección | 4960 | 1.1% |
| con | 3504 | 0.8% |
| ofertas | 3494 | 0.8% |
| Other values (23) | 14545 | 3.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 610241 | |
| t | 536474 | |
| n | 424774 | |
| i | 408804 | |
| c | 386758 | |
| r | 369306 | |
| e | 246109 | 5.8% |
| 241139 | 5.7% | |
| o | 189224 | 4.5% |
| ó | 182760 | 4.3% |
| Other values (32) | 620954 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 3754958 | |
| Space Separator | 241139 | 5.7% |
| Uppercase Letter | 211828 | 5.0% |
| Open Punctuation | 3494 | 0.1% |
| Close Punctuation | 3494 | 0.1% |
| Connector Punctuation | 815 | < 0.1% |
| Decimal Number | 489 | < 0.1% |
| Dash Punctuation | 326 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 610241 | |
| t | 536474 | |
| n | 424774 | |
| i | 408804 | |
| c | 386758 | |
| r | 369306 | |
| e | 246109 | |
| o | 189224 | 5.0% |
| ó | 182760 | 4.9% |
| d | 161999 | 4.3% |
| Other values (13) | 238509 | 6.4% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 180441 | |
| M | 18741 | 8.8% |
| S | 5386 | 2.5% |
| A | 2556 | 1.2% |
| D | 2543 | 1.2% |
| L | 1014 | 0.5% |
| N | 312 | 0.1% |
| P | 306 | 0.1% |
| O | 306 | 0.1% |
| E | 173 | 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 163 | |
| 0 | 163 | |
| 1 | 163 |
Space Separator
| Value | Count | Frequency (%) |
| 241139 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 3494 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 3494 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 815 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 326 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3966786 | |
| Common | 249757 | 5.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 610241 | |
| t | 536474 | |
| n | 424774 | |
| i | 408804 | |
| c | 386758 | |
| r | 369306 | |
| e | 246109 | |
| o | 189224 | 4.8% |
| ó | 182760 | 4.6% |
| C | 180441 | 4.5% |
| Other values (24) | 431895 |
Common
| Value | Count | Frequency (%) |
| 241139 | ||
| ( | 3494 | 1.4% |
| ) | 3494 | 1.4% |
| _ | 815 | 0.3% |
| - | 326 | 0.1% |
| 2 | 163 | 0.1% |
| 0 | 163 | 0.1% |
| 1 | 163 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3977339 | |
| None | 239204 | 5.7% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 610241 | |
| t | 536474 | |
| n | 424774 | |
| i | 408804 | |
| c | 386758 | |
| r | 369306 | |
| e | 246109 | |
| 241139 | 6.1% | |
| o | 189224 | 4.8% |
| C | 180441 | 4.5% |
| Other values (28) | 384069 |
None
| Value | Count | Frequency (%) |
| ó | 182760 | |
| Ã | 34450 | 14.4% |
| é | 21143 | 8.8% |
| ú | 851 | 0.4% |
Fecha de Firma
Date
| Distinct | 1557 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| Minimum | 2017-12-28 00:00:00 |
|---|---|
| Maximum | 2023-07-10 00:00:00 |
Histogram with fixed size bins (bins=50)
| Distinct | 1546 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| Minimum | 2019-01-01 00:00:00 |
|---|---|
| Maximum | 2023-07-11 00:00:00 |
Histogram with fixed size bins (bins=50)
| Distinct | 1963 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| Minimum | 2019-01-02 00:00:00 |
|---|---|
| Maximum | 2042-02-23 00:00:00 |
Histogram with fixed size bins (bins=50)
| Distinct | 561 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 174156 |
| Missing (%) | 87.3% |
| Memory size | 3.0 MiB |
| Minimum | 2009-01-18 00:00:00 |
|---|---|
| Maximum | 2021-08-19 00:00:00 |
Histogram with fixed size bins (bins=50)
| Distinct | 924 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 173961 |
| Missing (%) | 87.2% |
| Memory size | 3.0 MiB |
| Minimum | 2018-12-07 00:00:00 |
|---|---|
| Maximum | 2034-11-21 00:00:00 |
Histogram with fixed size bins (bins=50)
Valor del Contrato
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 83663 |
|---|---|
| Distinct (%) | 41.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.1282924 × 108 |
| Minimum | 0 |
|---|---|
| Maximum | 1.7997072 × 1012 |
| Zeros | 905 |
| Zeros (%) | 0.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3200000 |
| Q1 | 9522000 |
| median | 18823529 |
| Q3 | 37863000 |
| 95-th percentile | 2.1226495 × 108 |
| Maximum | 1.7997072 × 1012 |
| Range | 1.7997072 × 1012 |
| Interquartile range (IQR) | 28341000 |
Descriptive statistics
| Standard deviation | 4.1973346 × 109 |
|---|---|
| Coefficient of variation (CV) | 37.20077 |
| Kurtosis | 169450.81 |
| Mean | 1.1282924 × 108 |
| Median Absolute Deviation (MAD) | 11518703 |
| Skewness | 397.19712 |
| Sum | 2.2515188 × 1013 |
| Variance | 1.7617618 × 1019 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 12000000 | 1644 | 0.8% |
| 9000000 | 1489 | 0.7% |
| 6000000 | 1424 | 0.7% |
| 10000000 | 1301 | 0.7% |
| 15000000 | 1299 | 0.7% |
| 18000000 | 1273 | 0.6% |
| 21000000 | 1004 | 0.5% |
| 8000000 | 905 | 0.5% |
| 0 | 905 | 0.5% |
| 20000000 | 894 | 0.4% |
| Other values (83653) | 187413 |
| Value | Count | Frequency (%) |
| 0 | 905 | |
| 1 | 3 | < 0.1% |
| 4 | 2 | < 0.1% |
| 10 | 1 | < 0.1% |
| 15 | 1 | < 0.1% |
| 34 | 1 | < 0.1% |
| 81 | 1 | < 0.1% |
| 7790 | 1 | < 0.1% |
| 17500 | 1 | < 0.1% |
| 23500 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1.79970725 × 1012 | 1 | |
| 2.754010013 × 1011 | 1 | |
| 1.432822371 × 1011 | 1 | |
| 1.179277155 × 1011 | 1 | |
| 1.159367591 × 1011 | 1 | |
| 9.468352547 × 1010 | 1 | |
| 9.301749043 × 1010 | 1 | |
| 8.022376125 × 1010 | 1 | |
| 7.2486 × 1010 | 1 | |
| 7.127073569 × 1010 | 1 |
Valor Facturado
Real number (ℝ)
HIGH CORRELATION SKEWED ZEROS
| Distinct | 56685 |
|---|---|
| Distinct (%) | 28.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 45270222 |
| Minimum | 0 |
|---|---|
| Maximum | 1.7906829 × 1012 |
| Zeros | 82836 |
| Zeros (%) | 41.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 5800000 |
| Q3 | 20620480 |
| 95-th percentile | 67044579 |
| Maximum | 1.7906829 × 1012 |
| Range | 1.7906829 × 1012 |
| Interquartile range (IQR) | 20620480 |
Descriptive statistics
| Standard deviation | 4.0299543 × 109 |
|---|---|
| Coefficient of variation (CV) | 89.019981 |
| Kurtosis | 195337.61 |
| Mean | 45270222 |
| Median Absolute Deviation (MAD) | 5800000 |
| Skewness | 439.67183 |
| Sum | 9.0337182 × 1012 |
| Variance | 1.6240532 × 1019 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 82836 | |
| 12000000 | 992 | 0.5% |
| 6000000 | 894 | 0.4% |
| 9000000 | 852 | 0.4% |
| 10000000 | 768 | 0.4% |
| 15000000 | 763 | 0.4% |
| 18000000 | 746 | 0.4% |
| 7500000 | 547 | 0.3% |
| 8000000 | 546 | 0.3% |
| 21000000 | 538 | 0.3% |
| Other values (56675) | 110069 |
| Value | Count | Frequency (%) |
| 0 | 82836 | |
| 3 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| 20 | 1 | < 0.1% |
| 46 | 1 | < 0.1% |
| 86 | 1 | < 0.1% |
| 669 | 1 | < 0.1% |
| 4474 | 1 | < 0.1% |
| 7050 | 1 | < 0.1% |
| 7790 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1.790682932 × 1012 | 1 | |
| 4.256508058 × 1010 | 1 | |
| 4.1 × 1010 | 1 | |
| 3.851396796 × 1010 | 1 | |
| 3.777576256 × 1010 | 1 | |
| 3.6525104 × 1010 | 1 | |
| 3.220546131 × 1010 | 1 | |
| 3.108968021 × 1010 | 1 | |
| 3.050190129 × 1010 | 1 | |
| 2.641529826 × 1010 | 1 |
Valor Pendiente de Pago
Real number (ℝ)
HIGH CORRELATION SKEWED ZEROS
| Distinct | 62830 |
|---|---|
| Distinct (%) | 31.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 74860390 |
| Minimum | -1.3043882 × 108 |
|---|---|
| Maximum | 6.0072888 × 1011 |
| Zeros | 73431 |
| Zeros (%) | 36.8% |
| Negative | 363 |
| Negative (%) | 0.2% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | -1.3043882 × 108 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 4233018 |
| Q3 | 19200000 |
| 95-th percentile | 1.181664 × 108 |
| Maximum | 6.0072888 × 1011 |
| Range | 6.0085932 × 1011 |
| Interquartile range (IQR) | 19200000 |
Descriptive statistics
| Standard deviation | 1.7676659 × 109 |
|---|---|
| Coefficient of variation (CV) | 23.612833 |
| Kurtosis | 70570.8 |
| Mean | 74860390 |
| Median Absolute Deviation (MAD) | 4233018 |
| Skewness | 228.54718 |
| Sum | 1.4938466 × 1013 |
| Variance | 3.1246427 × 1018 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 73431 | |
| 9000000 | 752 | 0.4% |
| 12000000 | 736 | 0.4% |
| 6000000 | 734 | 0.4% |
| 1 | 699 | 0.4% |
| 10000000 | 596 | 0.3% |
| 18000000 | 577 | 0.3% |
| 15000000 | 549 | 0.3% |
| 3000000 | 545 | 0.3% |
| 21000000 | 469 | 0.2% |
| Other values (62820) | 120463 |
| Value | Count | Frequency (%) |
| -130438820 | 1 | |
| -63433305 | 1 | |
| -49524712 | 1 | |
| -41925317 | 1 | |
| -37314433 | 1 | |
| -36905725 | 1 | |
| -36370295 | 1 | |
| -33634138 | 1 | |
| -32912750 | 1 | |
| -31511887 | 1 |
| Value | Count | Frequency (%) |
| 6.007288838 × 1011 | 1 | |
| 2.754010013 × 1011 | 1 | |
| 1.459392215 × 1011 | 1 | |
| 1.432822371 × 1011 | 1 | |
| 1.179277155 × 1011 | 1 | |
| 1.159367591 × 1011 | 1 | |
| 9.468352547 × 1010 | 1 | |
| 9.301749043 × 1010 | 1 | |
| 8.022376125 × 1010 | 1 | |
| 7.127073569 × 1010 | 1 |
Valor Pagado
Real number (ℝ)
HIGH CORRELATION SKEWED ZEROS
| Distinct | 52334 |
|---|---|
| Distinct (%) | 26.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41143799 |
| Minimum | 0 |
|---|---|
| Maximum | 1.653768 × 1012 |
| Zeros | 93285 |
| Zeros (%) | 46.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 3247501 |
| Q3 | 18424998 |
| 95-th percentile | 61546100 |
| Maximum | 1.653768 × 1012 |
| Range | 1.653768 × 1012 |
| Interquartile range (IQR) | 18424998 |
Descriptive statistics
| Standard deviation | 3.7228078 × 109 |
|---|---|
| Coefficient of variation (CV) | 90.482841 |
| Kurtosis | 195131.95 |
| Mean | 41143799 |
| Median Absolute Deviation (MAD) | 3247501 |
| Skewness | 439.33122 |
| Sum | 8.2102862 × 1012 |
| Variance | 1.3859298 × 1019 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 93285 | |
| 12000000 | 874 | 0.4% |
| 6000000 | 784 | 0.4% |
| 9000000 | 752 | 0.4% |
| 10000000 | 681 | 0.3% |
| 15000000 | 659 | 0.3% |
| 18000000 | 630 | 0.3% |
| 8000000 | 474 | 0.2% |
| 21000000 | 463 | 0.2% |
| 7500000 | 457 | 0.2% |
| Other values (52324) | 100492 |
| Value | Count | Frequency (%) |
| 0 | 93285 | |
| 3 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| 20 | 1 | < 0.1% |
| 46 | 1 | < 0.1% |
| 86 | 1 | < 0.1% |
| 669 | 1 | < 0.1% |
| 4474 | 1 | < 0.1% |
| 7050 | 1 | < 0.1% |
| 7790 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1.653768028 × 1012 | 1 | |
| 4.256508058 × 1010 | 1 | |
| 4.1 × 1010 | 1 | |
| 3.851396796 × 1010 | 1 | |
| 3.6525104 × 1010 | 1 | |
| 3.255813844 × 1010 | 1 | |
| 3.220546131 × 1010 | 1 | |
| 2.629074506 × 1010 | 1 | |
| 2.622931772 × 1010 | 1 | |
| 2.600365765 × 1010 | 1 |
Valor Pendiente de Ejecucion
Real number (ℝ)
HIGH CORRELATION SKEWED ZEROS
| Distinct | 62874 |
|---|---|
| Distinct (%) | 31.6% |
| Missing | 346 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 70963310 |
| Minimum | -1.3043882 × 108 |
|---|---|
| Maximum | 2.75401 × 1011 |
| Zeros | 73005 |
| Zeros (%) | 36.6% |
| Negative | 357 |
| Negative (%) | 0.2% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | -1.3043882 × 108 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 4290000 |
| Q3 | 19200000 |
| 95-th percentile | 1.1849 × 108 |
| Maximum | 2.75401 × 1011 |
| Range | 2.7553144 × 1011 |
| Interquartile range (IQR) | 19200000 |
Descriptive statistics
| Standard deviation | 1.0934342 × 109 |
|---|---|
| Coefficient of variation (CV) | 15.408444 |
| Kurtosis | 24105.374 |
| Mean | 70963310 |
| Median Absolute Deviation (MAD) | 4290000 |
| Skewness | 122.49927 |
| Sum | 1.4136246 × 1013 |
| Variance | 1.1955983 × 1018 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 73005 | |
| 9000000 | 752 | 0.4% |
| 12000000 | 736 | 0.4% |
| 6000000 | 735 | 0.4% |
| 1 | 700 | 0.4% |
| 10000000 | 597 | 0.3% |
| 18000000 | 577 | 0.3% |
| 15000000 | 549 | 0.3% |
| 3000000 | 543 | 0.3% |
| 21000000 | 469 | 0.2% |
| Other values (62864) | 120542 |
| Value | Count | Frequency (%) |
| -130438820 | 1 | |
| -63433305 | 1 | |
| -49524712 | 1 | |
| -41925317 | 1 | |
| -37314433 | 1 | |
| -36905725 | 1 | |
| -36370295 | 1 | |
| -33634138 | 1 | |
| -32912750 | 1 | |
| -31511887 | 1 |
| Value | Count | Frequency (%) |
| 2.754010013 × 1011 | 1 | |
| 1.432822371 × 1011 | 1 | |
| 1.179277155 × 1011 | 1 | |
| 1.159367591 × 1011 | 1 | |
| 9.468352547 × 1010 | 1 | |
| 9.301749043 × 1010 | 1 | |
| 8.022376125 × 1010 | 1 | |
| 7.127073569 × 1010 | 1 | |
| 6.9486 × 1010 | 1 | |
| 5.678123846 × 1010 | 1 |
Saldo CDP
Real number (ℝ)
HIGH CORRELATION SKEWED ZEROS
| Distinct | 70861 |
|---|---|
| Distinct (%) | 35.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.7639314 × 109 |
| Minimum | 0 |
|---|---|
| Maximum | 4.3015709 × 1013 |
| Zeros | 10520 |
| Zeros (%) | 5.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 11266668 |
| median | 30100000 |
| Q3 | 2.214 × 108 |
| 95-th percentile | 4.8087477 × 109 |
| Maximum | 4.3015709 × 1013 |
| Range | 4.3015709 × 1013 |
| Interquartile range (IQR) | 2.1013333 × 108 |
Descriptive statistics
| Standard deviation | 1.7690117 × 1011 |
|---|---|
| Coefficient of variation (CV) | 64.003461 |
| Kurtosis | 52688.64 |
| Mean | 2.7639314 × 109 |
| Median Absolute Deviation (MAD) | 24900000 |
| Skewness | 220.06392 |
| Sum | 5.5154527 × 1014 |
| Variance | 3.1294025 × 1022 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 10520 | 5.3% |
| 12000000 | 1240 | 0.6% |
| 15000000 | 1190 | 0.6% |
| 10000000 | 1129 | 0.6% |
| 9000000 | 1005 | 0.5% |
| 6000000 | 988 | 0.5% |
| 20000000 | 926 | 0.5% |
| 18000000 | 910 | 0.5% |
| 30000000 | 775 | 0.4% |
| 21000000 | 750 | 0.4% |
| Other values (70851) | 180118 |
| Value | Count | Frequency (%) |
| 0 | 10520 | |
| 1 | 3 | < 0.1% |
| 15 | 1 | < 0.1% |
| 17 | 1 | < 0.1% |
| 744 | 1 | < 0.1% |
| 876 | 1 | < 0.1% |
| 2600 | 1 | < 0.1% |
| 21700 | 1 | < 0.1% |
| 49000 | 1 | < 0.1% |
| 93821 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 4.301570889 × 1013 | 1 | < 0.1% |
| 4.301160446 × 1013 | 2 | < 0.1% |
| 9.673198774 × 1012 | 1 | < 0.1% |
| 6.750000001 × 1012 | 5 | |
| 6.11985 × 1012 | 1 | < 0.1% |
| 6.11645 × 1012 | 1 | < 0.1% |
| 6.11325 × 1012 | 2 | < 0.1% |
| 6.10655 × 1012 | 3 | |
| 6.1065 × 1012 | 1 | < 0.1% |
| 4.138797195 × 1012 | 1 | < 0.1% |
Destino Gasto
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| Inversión | |
|---|---|
| Funcionamiento | |
| No Definido | 850 |
Length
| Max length | 14 |
|---|---|
| Median length | 9 |
| Mean length | 10.747523 |
| Min length | 9 |
Characters and Unicode
| Total characters | 2144679 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Funcionamiento |
|---|---|
| 2nd row | Funcionamiento |
| 3rd row | Funcionamiento |
| 4th row | Inversión |
| 5th row | Inversión |
Common Values
| Value | Count | Frequency (%) |
| Inversión | 129297 | |
| Funcionamiento | 69404 | |
| No Definido | 850 | 0.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| inversión | 129297 | |
| funcionamiento | 69404 | |
| no | 850 | 0.4% |
| definido | 850 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 467656 | |
| i | 269805 | |
| e | 199551 | |
| o | 140508 | 6.6% |
| I | 129297 | 6.0% |
| v | 129297 | 6.0% |
| r | 129297 | 6.0% |
| s | 129297 | 6.0% |
| ó | 129297 | 6.0% |
| a | 69404 | 3.2% |
| Other values (10) | 351270 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1943428 | |
| Uppercase Letter | 200401 | 9.3% |
| Space Separator | 850 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 467656 | |
| i | 269805 | |
| e | 199551 | |
| o | 140508 | 7.2% |
| v | 129297 | 6.7% |
| r | 129297 | 6.7% |
| s | 129297 | 6.7% |
| ó | 129297 | 6.7% |
| a | 69404 | 3.6% |
| t | 69404 | 3.6% |
| Other values (5) | 209912 |
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 129297 | |
| F | 69404 | |
| N | 850 | 0.4% |
| D | 850 | 0.4% |
Space Separator
| Value | Count | Frequency (%) |
| 850 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2143829 | |
| Common | 850 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 467656 | |
| i | 269805 | |
| e | 199551 | |
| o | 140508 | 6.6% |
| I | 129297 | 6.0% |
| v | 129297 | 6.0% |
| r | 129297 | 6.0% |
| s | 129297 | 6.0% |
| ó | 129297 | 6.0% |
| a | 69404 | 3.2% |
| Other values (9) | 350420 |
Common
| Value | Count | Frequency (%) |
| 850 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2015382 | |
| None | 129297 | 6.0% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 467656 | |
| i | 269805 | |
| e | 199551 | |
| o | 140508 | 7.0% |
| I | 129297 | 6.4% |
| v | 129297 | 6.4% |
| r | 129297 | 6.4% |
| s | 129297 | 6.4% |
| a | 69404 | 3.4% |
| t | 69404 | 3.4% |
| Other values (9) | 281866 |
None
| Value | Count | Frequency (%) |
| ó | 129297 |
Dias Adicionados
Real number (ℝ)
SKEWED ZEROS
| Distinct | 149 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.41119313 |
| Minimum | 0 |
|---|---|
| Maximum | 1160 |
| Zeros | 198518 |
| Zeros (%) | 99.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 1160 |
| Range | 1160 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 8.5639885 |
|---|---|
| Coefficient of variation (CV) | 20.827168 |
| Kurtosis | 2345.1162 |
| Mean | 0.41119313 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 35.403316 |
| Sum | 82054 |
| Variance | 73.341899 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 198518 | |
| 30 | 101 | 0.1% |
| 31 | 73 | < 0.1% |
| 214 | 69 | < 0.1% |
| 1 | 40 | < 0.1% |
| 92 | 37 | < 0.1% |
| 4 | 35 | < 0.1% |
| 61 | 31 | < 0.1% |
| 91 | 28 | < 0.1% |
| 244 | 27 | < 0.1% |
| Other values (139) | 592 | 0.3% |
| Value | Count | Frequency (%) |
| 0 | 198518 | |
| 1 | 40 | < 0.1% |
| 2 | 22 | < 0.1% |
| 3 | 17 | < 0.1% |
| 4 | 35 | < 0.1% |
| 5 | 10 | < 0.1% |
| 6 | 13 | < 0.1% |
| 7 | 19 | < 0.1% |
| 8 | 12 | < 0.1% |
| 9 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 1160 | 1 | |
| 398 | 1 | |
| 379 | 1 | |
| 369 | 1 | |
| 368 | 1 | |
| 365 | 1 | |
| 350 | 1 | |
| 343 | 1 | |
| 337 | 2 | |
| 335 | 1 |
Género Representante Legal
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| No Definido | |
|---|---|
| Mujer | |
| Hombre | |
| Otro | 185 |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 8.9688 |
| Min length | 4 |
Characters and Unicode
| Total characters | 1789733 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Mujer |
|---|---|
| 2nd row | Hombre |
| 3rd row | Hombre |
| 4th row | No Definido |
| 5th row | Hombre |
Common Values
| Value | Count | Frequency (%) |
| No Definido | 126227 | |
| Mujer | 38338 | 19.2% |
| Hombre | 34801 | 17.4% |
| Otro | 185 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| no | 126227 | |
| definido | 126227 | |
| mujer | 38338 | 11.8% |
| hombre | 34801 | 10.7% |
| otro | 185 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 287440 | |
| i | 252454 | |
| e | 199366 | |
| N | 126227 | |
| 126227 | ||
| D | 126227 | |
| f | 126227 | |
| n | 126227 | |
| d | 126227 | |
| r | 73324 | 4.1% |
| Other values (8) | 219787 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1337728 | |
| Uppercase Letter | 325778 | 18.2% |
| Space Separator | 126227 | 7.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 287440 | |
| i | 252454 | |
| e | 199366 | |
| f | 126227 | |
| n | 126227 | |
| d | 126227 | |
| r | 73324 | 5.5% |
| j | 38338 | 2.9% |
| u | 38338 | 2.9% |
| m | 34801 | 2.6% |
| Other values (2) | 34986 | 2.6% |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 126227 | |
| D | 126227 | |
| M | 38338 | 11.8% |
| H | 34801 | 10.7% |
| O | 185 | 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 126227 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1663506 | |
| Common | 126227 | 7.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 287440 | |
| i | 252454 | |
| e | 199366 | |
| N | 126227 | |
| D | 126227 | |
| f | 126227 | |
| n | 126227 | |
| d | 126227 | |
| r | 73324 | 4.4% |
| j | 38338 | 2.3% |
| Other values (7) | 181449 |
Common
| Value | Count | Frequency (%) |
| 126227 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1789733 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 287440 | |
| i | 252454 | |
| e | 199366 | |
| N | 126227 | |
| 126227 | ||
| D | 126227 | |
| f | 126227 | |
| n | 126227 | |
| d | 126227 | |
| r | 73324 | 4.1% |
| Other values (8) | 219787 |
Presupuesto General de la Nacion – PGN
Real number (ℝ)
SKEWED ZEROS
| Distinct | 25823 |
|---|---|
| Distinct (%) | 12.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40828738 |
| Minimum | 0 |
|---|---|
| Maximum | 1.7997072 × 1012 |
| Zeros | 161214 |
| Zeros (%) | 80.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 52000000 |
| Maximum | 1.7997072 × 1012 |
| Range | 1.7997072 × 1012 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 4.0557039 × 109 |
|---|---|
| Coefficient of variation (CV) | 99.33454 |
| Kurtosis | 194294.54 |
| Mean | 40828738 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 437.96132 |
| Sum | 8.1474154 × 1012 |
| Variance | 1.6448734 × 1019 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 161214 | |
| 41973750 | 103 | 0.1% |
| 15000000 | 101 | 0.1% |
| 20000000 | 99 | < 0.1% |
| 30000000 | 98 | < 0.1% |
| 10000000 | 89 | < 0.1% |
| 24000000 | 83 | < 0.1% |
| 12000000 | 83 | < 0.1% |
| 27500000 | 78 | < 0.1% |
| 18000000 | 76 | < 0.1% |
| Other values (25813) | 37527 | 18.8% |
| Value | Count | Frequency (%) |
| 0 | 161214 | |
| 7790 | 1 | < 0.1% |
| 34605 | 1 | < 0.1% |
| 43600 | 1 | < 0.1% |
| 67400 | 1 | < 0.1% |
| 79900 | 1 | < 0.1% |
| 85000 | 1 | < 0.1% |
| 99000 | 1 | < 0.1% |
| 100000 | 1 | < 0.1% |
| 109000 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1.79970725 × 1012 | 1 | |
| 7.127073569 × 1010 | 1 | |
| 5.667932482 × 1010 | 1 | |
| 5.44 × 1010 | 1 | |
| 5.242879448 × 1010 | 1 | |
| 4.2225 × 1010 | 1 | |
| 4.1 × 1010 | 1 | |
| 3.8 × 1010 | 1 | |
| 3.6525104 × 1010 | 1 | |
| 3.325 × 1010 | 1 |
Recursos Propios (AlcaldÃas, Gobernaciones y Resguardos IndÃgenas)
Real number (ℝ)
SKEWED ZEROS
| Distinct | 27000 |
|---|---|
| Distinct (%) | 13.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23031137 |
| Minimum | 0 |
|---|---|
| Maximum | 1.1792772 × 1011 |
| Zeros | 110760 |
| Zeros (%) | 55.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 12150000 |
| 95-th percentile | 41985500 |
| Maximum | 1.1792772 × 1011 |
| Range | 1.1792772 × 1011 |
| Interquartile range (IQR) | 12150000 |
Descriptive statistics
| Standard deviation | 4.6727841 × 108 |
|---|---|
| Coefficient of variation (CV) | 20.288985 |
| Kurtosis | 39870.885 |
| Mean | 23031137 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 169.38952 |
| Sum | 4.5958865 × 1012 |
| Variance | 2.1834911 × 1017 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 110760 | |
| 12000000 | 1146 | 0.6% |
| 9000000 | 1076 | 0.5% |
| 6000000 | 1011 | 0.5% |
| 18000000 | 875 | 0.4% |
| 10000000 | 866 | 0.4% |
| 15000000 | 831 | 0.4% |
| 21000000 | 730 | 0.4% |
| 8000000 | 605 | 0.3% |
| 3000000 | 550 | 0.3% |
| Other values (26990) | 81101 |
| Value | Count | Frequency (%) |
| 0 | 110760 | |
| 1 | 1 | < 0.1% |
| 39401 | 2 | < 0.1% |
| 50000 | 1 | < 0.1% |
| 51492 | 1 | < 0.1% |
| 73696 | 1 | < 0.1% |
| 93580 | 1 | < 0.1% |
| 100000 | 2 | < 0.1% |
| 110000 | 1 | < 0.1% |
| 112000 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1.179277155 × 1011 | 1 | |
| 1.159367591 × 1011 | 1 | |
| 3.20584563 × 1010 | 1 | |
| 3.180563051 × 1010 | 1 | |
| 2.679999908 × 1010 | 1 | |
| 2.629074506 × 1010 | 1 | |
| 2.604050006 × 1010 | 1 | |
| 2.45 × 1010 | 1 | |
| 2.426897467 × 1010 | 1 | |
| 2.053847255 × 1010 | 1 |
Recursos Propios
Real number (ℝ)
SKEWED ZEROS
| Distinct | 18687 |
|---|---|
| Distinct (%) | 9.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13141530 |
| Minimum | 0 |
|---|---|
| Maximum | 9.4683525 × 1010 |
| Zeros | 165174 |
| Zeros (%) | 82.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 32869334 |
| Maximum | 9.4683525 × 1010 |
| Range | 9.4683525 × 1010 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 3.6657558 × 108 |
|---|---|
| Coefficient of variation (CV) | 27.894437 |
| Kurtosis | 31307.212 |
| Mean | 13141530 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 149.50094 |
| Sum | 2.6224055 × 1012 |
| Variance | 1.3437766 × 1017 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 165174 | |
| 12000000 | 242 | 0.1% |
| 6000000 | 241 | 0.1% |
| 15000000 | 237 | 0.1% |
| 10000000 | 214 | 0.1% |
| 9000000 | 213 | 0.1% |
| 24000000 | 182 | 0.1% |
| 18000000 | 171 | 0.1% |
| 20000000 | 167 | 0.1% |
| 21000000 | 161 | 0.1% |
| Other values (18677) | 32549 | 16.3% |
| Value | Count | Frequency (%) |
| 0 | 165174 | |
| 1 | 1 | < 0.1% |
| 2 | 1 | < 0.1% |
| 61832 | 1 | < 0.1% |
| 68000 | 1 | < 0.1% |
| 71444 | 1 | < 0.1% |
| 93262 | 1 | < 0.1% |
| 130900 | 1 | < 0.1% |
| 142800 | 1 | < 0.1% |
| 150000 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 9.468352547 × 1010 | 1 | |
| 6.9486 × 1010 | 1 | |
| 4.929783084 × 1010 | 1 | |
| 2.83910293 × 1010 | 1 | |
| 2.482858222 × 1010 | 1 | |
| 2.429802354 × 1010 | 1 | |
| 2.394275368 × 1010 | 1 | |
| 2.124645046 × 1010 | 1 | |
| 2.104367381 × 1010 | 1 | |
| 1.93806224 × 1010 | 1 |
EsServicioPublico
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 146971 | |
| True | 52580 | 26.3% |
EsPrestacionServicios
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 169166 | |
| False | 30385 | 15.2% |
EsGrupo
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| False | |
|---|---|
| True | 1258 |
| Value | Count | Frequency (%) |
| False | 198293 | |
| True | 1258 | 0.6% |
EsPyme
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 161970 | |
| True | 37581 | 18.8% |
EstaLiquidado
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 170174 | |
| True | 29377 | 14.7% |
EsObligacionAmbiental
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| False | |
|---|---|
| True | 7698 |
| Value | Count | Frequency (%) |
| False | 191853 | |
| True | 7698 | 3.9% |
Es PostConflicto
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| False | |
|---|---|
| True | 950 |
| Value | Count | Frequency (%) |
| False | 198601 | |
| True | 950 | 0.5% |
EsRecursosPropios
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 166854 | |
| True | 32697 | 16.4% |
| Valor del Contrato | Valor Facturado | Valor Pendiente de Pago | Valor Pagado | Valor Pendiente de Ejecucion | Saldo CDP | Dias Adicionados | Presupuesto General de la Nacion – PGN | Recursos Propios (AlcaldÃas, Gobernaciones y Resguardos IndÃgenas) | Recursos Propios | Departamento | Orden | Rama | Entidad Centralizada | Estado Contrato | Modalidad de Contratacion | Destino Gasto | Género Representante Legal | EsServicioPublico | EsPrestacionServicios | EsGrupo | EsPyme | EstaLiquidado | EsObligacionAmbiental | Es PostConflicto | EsRecursosPropios | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Valor del Contrato | 1.000 | 0.330 | 0.383 | 0.282 | 0.384 | 0.539 | 0.005 | 0.244 | -0.045 | 0.048 | 0.000 | 0.000 | 0.001 | 0.000 | 0.019 | 0.042 | 0.000 | 0.000 | 0.000 | 0.004 | 0.040 | 0.000 | 0.004 | 0.000 | 0.000 | 0.000 |
| Valor Facturado | 0.330 | 1.000 | -0.579 | 0.918 | -0.582 | 0.172 | -0.026 | 0.179 | -0.039 | -0.041 | 0.000 | 0.000 | 0.004 | 0.000 | 0.000 | 0.018 | 0.000 | 0.002 | 0.000 | 0.000 | 0.014 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| Valor Pendiente de Pago | 0.383 | -0.579 | 1.000 | -0.682 | 1.000 | 0.214 | 0.024 | 0.012 | 0.013 | 0.082 | 0.000 | 0.000 | 0.000 | 0.000 | 0.016 | 0.031 | 0.000 | 0.000 | 0.000 | 0.010 | 0.040 | 0.000 | 0.009 | 0.000 | 0.000 | 0.000 |
| Valor Pagado | 0.282 | 0.918 | -0.682 | 1.000 | -0.685 | 0.146 | -0.023 | 0.170 | -0.056 | -0.040 | 0.000 | 0.000 | 0.004 | 0.000 | 0.000 | 0.018 | 0.000 | 0.002 | 0.000 | 0.000 | 0.014 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| Valor Pendiente de Ejecucion | 0.384 | -0.582 | 1.000 | -0.685 | 1.000 | 0.215 | 0.024 | 0.012 | 0.013 | 0.082 | 0.000 | 0.002 | 0.000 | 0.005 | 0.021 | 0.036 | 0.000 | 0.000 | 0.000 | 0.023 | 0.041 | 0.000 | 0.015 | 0.000 | 0.000 | 0.000 |
| Saldo CDP | 0.539 | 0.172 | 0.214 | 0.146 | 0.215 | 1.000 | 0.043 | 0.242 | -0.096 | -0.013 | 0.004 | 0.003 | 0.000 | 0.005 | 0.001 | 0.011 | 0.007 | 0.005 | 0.005 | 0.001 | 0.000 | 0.000 | 0.005 | 0.000 | 0.000 | 0.001 |
| Dias Adicionados | 0.005 | -0.026 | 0.024 | -0.023 | 0.024 | 0.043 | 1.000 | -0.027 | -0.048 | 0.008 | 0.022 | 0.015 | 0.009 | 0.021 | 0.021 | 0.044 | 0.029 | 0.014 | 0.020 | 0.016 | 0.000 | 0.006 | 0.012 | 0.003 | 0.000 | 0.005 |
| Presupuesto General de la Nacion – PGN | 0.244 | 0.179 | 0.012 | 0.170 | 0.012 | 0.242 | -0.027 | 1.000 | -0.403 | -0.179 | 0.000 | 0.000 | 0.004 | 0.000 | 0.000 | 0.018 | 0.000 | 0.002 | 0.000 | 0.000 | 0.014 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| Recursos Propios (AlcaldÃas, Gobernaciones y Resguardos IndÃgenas) | -0.045 | -0.039 | 0.013 | -0.056 | 0.013 | -0.096 | -0.048 | -0.403 | 1.000 | -0.366 | 0.008 | 0.003 | 0.000 | 0.005 | 0.008 | 0.044 | 0.000 | 0.000 | 0.006 | 0.019 | 0.044 | 0.000 | 0.008 | 0.000 | 0.000 | 0.003 |
| Recursos Propios | 0.048 | -0.041 | 0.082 | -0.040 | 0.082 | -0.013 | 0.008 | -0.179 | -0.366 | 1.000 | 0.000 | 0.014 | 0.006 | 0.008 | 0.021 | 0.042 | 0.000 | 0.000 | 0.004 | 0.018 | 0.052 | 0.000 | 0.012 | 0.000 | 0.000 | 0.021 |
| Departamento | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.004 | 0.022 | 0.000 | 0.008 | 0.000 | 1.000 | 0.272 | 0.136 | 0.322 | 0.210 | 0.091 | 0.177 | 0.165 | 0.418 | 0.171 | 0.054 | 0.108 | 0.250 | 0.205 | 0.081 | 0.172 |
| Orden | 0.000 | 0.000 | 0.000 | 0.000 | 0.002 | 0.003 | 0.015 | 0.000 | 0.003 | 0.014 | 0.272 | 1.000 | 0.243 | 0.121 | 0.071 | 0.159 | 0.067 | 0.158 | 0.415 | 0.172 | 0.021 | 0.140 | 0.099 | 0.222 | 0.074 | 0.197 |
| Rama | 0.001 | 0.004 | 0.000 | 0.004 | 0.000 | 0.000 | 0.009 | 0.004 | 0.000 | 0.006 | 0.136 | 0.243 | 1.000 | 0.040 | 0.047 | 0.137 | 0.147 | 0.048 | 0.193 | 0.132 | 0.020 | 0.080 | 0.104 | 0.043 | 0.064 | 0.313 |
| Entidad Centralizada | 0.000 | 0.000 | 0.000 | 0.000 | 0.005 | 0.005 | 0.021 | 0.000 | 0.005 | 0.008 | 0.322 | 0.121 | 0.040 | 1.000 | 0.058 | 0.112 | 0.041 | 0.059 | 0.070 | 0.005 | 0.017 | 0.038 | 0.029 | 0.119 | 0.056 | 0.140 |
| Estado Contrato | 0.019 | 0.000 | 0.016 | 0.000 | 0.021 | 0.001 | 0.021 | 0.000 | 0.008 | 0.021 | 0.210 | 0.071 | 0.047 | 0.058 | 1.000 | 0.199 | 0.052 | 0.033 | 0.041 | 0.152 | 0.158 | 0.081 | 0.076 | 0.014 | 0.050 | 0.042 |
| Modalidad de Contratacion | 0.042 | 0.018 | 0.031 | 0.018 | 0.036 | 0.011 | 0.044 | 0.018 | 0.044 | 0.042 | 0.091 | 0.159 | 0.137 | 0.112 | 0.199 | 1.000 | 0.243 | 0.131 | 0.203 | 0.680 | 0.472 | 0.516 | 0.323 | 0.071 | 0.076 | 0.189 |
| Destino Gasto | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.007 | 0.029 | 0.000 | 0.000 | 0.000 | 0.177 | 0.067 | 0.147 | 0.041 | 0.052 | 0.243 | 1.000 | 0.047 | 0.120 | 0.146 | 0.005 | 0.081 | 0.105 | 0.087 | 0.012 | 0.119 |
| Género Representante Legal | 0.000 | 0.002 | 0.000 | 0.002 | 0.000 | 0.005 | 0.014 | 0.002 | 0.000 | 0.000 | 0.165 | 0.158 | 0.048 | 0.059 | 0.033 | 0.131 | 0.047 | 1.000 | 0.123 | 0.173 | 0.052 | 0.177 | 0.098 | 0.083 | 0.012 | 0.070 |
| EsServicioPublico | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.005 | 0.020 | 0.000 | 0.006 | 0.004 | 0.418 | 0.415 | 0.193 | 0.070 | 0.041 | 0.203 | 0.120 | 0.123 | 1.000 | 0.105 | 0.000 | 0.067 | 0.039 | 0.099 | 0.023 | 0.167 |
| EsPrestacionServicios | 0.004 | 0.000 | 0.010 | 0.000 | 0.023 | 0.001 | 0.016 | 0.000 | 0.019 | 0.018 | 0.171 | 0.172 | 0.132 | 0.005 | 0.152 | 0.680 | 0.146 | 0.173 | 0.105 | 1.000 | 0.135 | 0.306 | 0.210 | 0.013 | 0.000 | 0.027 |
| EsGrupo | 0.040 | 0.014 | 0.040 | 0.014 | 0.041 | 0.000 | 0.000 | 0.014 | 0.044 | 0.052 | 0.054 | 0.021 | 0.020 | 0.017 | 0.158 | 0.472 | 0.005 | 0.052 | 0.000 | 0.135 | 1.000 | 0.010 | 0.079 | 0.002 | 0.010 | 0.006 |
| EsPyme | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.006 | 0.000 | 0.000 | 0.000 | 0.108 | 0.140 | 0.080 | 0.038 | 0.081 | 0.516 | 0.081 | 0.177 | 0.067 | 0.306 | 0.010 | 1.000 | 0.168 | 0.042 | 0.000 | 0.021 |
| EstaLiquidado | 0.004 | 0.000 | 0.009 | 0.000 | 0.015 | 0.005 | 0.012 | 0.000 | 0.008 | 0.012 | 0.250 | 0.099 | 0.104 | 0.029 | 0.076 | 0.323 | 0.105 | 0.098 | 0.039 | 0.210 | 0.079 | 0.168 | 1.000 | 0.037 | 0.000 | 0.052 |
| EsObligacionAmbiental | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.003 | 0.000 | 0.000 | 0.000 | 0.205 | 0.222 | 0.043 | 0.119 | 0.014 | 0.071 | 0.087 | 0.083 | 0.099 | 0.013 | 0.002 | 0.042 | 0.037 | 1.000 | 0.010 | 0.042 |
| Es PostConflicto | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.081 | 0.074 | 0.064 | 0.056 | 0.050 | 0.076 | 0.012 | 0.012 | 0.023 | 0.000 | 0.010 | 0.000 | 0.000 | 0.010 | 1.000 | 0.029 |
| EsRecursosPropios | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.001 | 0.005 | 0.000 | 0.003 | 0.021 | 0.172 | 0.197 | 0.313 | 0.140 | 0.042 | 0.189 | 0.119 | 0.070 | 0.167 | 0.027 | 0.006 | 0.021 | 0.052 | 0.042 | 0.029 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| Departamento | Orden | Rama | Entidad Centralizada | Estado Contrato | Modalidad de Contratacion | Fecha de Firma | Fecha de Inicio del Contrato | Fecha de Fin del Contrato | Fecha de Inicio de Ejecucion | Fecha de Fin de Ejecucion | Valor del Contrato | Valor Facturado | Valor Pendiente de Pago | Valor Pagado | Valor Pendiente de Ejecucion | Saldo CDP | Destino Gasto | Dias Adicionados | Género Representante Legal | Presupuesto General de la Nacion – PGN | Recursos Propios (AlcaldÃas, Gobernaciones y Resguardos IndÃgenas) | Recursos Propios | EsServicioPublico | EsPrestacionServicios | EsGrupo | EsPyme | EstaLiquidado | EsObligacionAmbiental | Es PostConflicto | EsRecursosPropios | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2517415 | Antioquia | Nacional | Corporación Autónoma | Centralizada | Cerrado | Contratación directa | 2022-08-01 | 2022-08-01 | 2022-12-16 | NaT | NaT | 11892679 | 0 | 11892679 | 0 | 11892679.0 | 37931294 | Funcionamiento | 0 | Mujer | 0 | 11892679 | 0 | False | True | False | False | False | False | False | False |
| 884993 | Distrito Capital de Bogotá | Nacional | Ejecutivo | Centralizada | cedido | Contratación régimen especial | 2022-01-05 | 2022-01-07 | 2022-12-21 | NaT | NaT | 69310500 | 0 | 69310500 | 0 | 69310500.0 | 69310500 | Funcionamiento | 0 | Hombre | 0 | 0 | 69310500 | False | True | False | False | False | True | False | True |
| 590266 | Santander | Corporación Autónoma | Corporación Autónoma | Centralizada | Cerrado | Contratación directa | 2022-01-28 | 2022-02-01 | 2022-09-15 | NaT | NaT | 12750000 | 12750000 | 0 | 12750000 | 0.0 | 12750000 | Funcionamiento | 0 | Hombre | 0 | 0 | 12750000 | False | True | False | False | True | False | False | True |
| 1649794 | Boyacá | Territorial | Ejecutivo | Descentralizada | terminado | Contratación directa | 2022-01-20 | 2022-01-21 | 2022-09-20 | NaT | NaT | 24450456 | 24450456 | 0 | 24450456 | 0.0 | 24450456 | Inversión | 0 | No Definido | 0 | 24450456 | 0 | True | True | False | False | False | False | False | False |
| 1148398 | Antioquia | Territorial | Ejecutivo | Descentralizada | terminado | Contratación directa | 2022-08-03 | 2022-08-04 | 2022-10-19 | NaT | NaT | 4059600 | 4059600 | 0 | 4059600 | 0.0 | 4059600 | Inversión | 0 | Hombre | 0 | 4059600 | 0 | False | True | False | False | False | False | False | False |
| 569984 | Valle del Cauca | Territorial | Ejecutivo | Centralizada | Cerrado | Contratación directa | 2020-07-16 | 2020-07-17 | 2020-10-31 | NaT | NaT | 19892436 | 0 | 19892436 | 0 | 19892436.0 | 45965395 | Inversión | 0 | No Definido | 0 | 19892436 | 0 | True | True | False | False | False | False | False | False |
| 1377876 | BolÃvar | Territorial | Ejecutivo | Descentralizada | terminado | Contratación directa | 2022-09-28 | 2022-09-29 | 2022-12-28 | NaT | NaT | 13500000 | 13500000 | 13500000 | 0 | 13500000.0 | 100000000 | Inversión | 0 | No Definido | 0 | 0 | 0 | True | True | False | True | False | False | False | False |
| 813532 | Valle del Cauca | Territorial | Ejecutivo | Centralizada | terminado | Contratación directa | 2020-09-10 | 2020-09-16 | 2020-12-31 | NaT | NaT | 12000000 | 0 | 12000000 | 0 | 12000000.0 | 209300000 | Inversión | 0 | No Definido | 0 | 12000000 | 0 | True | True | False | False | False | False | False | False |
| 974462 | Huila | Territorial | Corporación Autónoma | Descentralizada | terminado | Contratación régimen especial | 2022-08-02 | 2022-08-02 | 2022-10-26 | NaT | NaT | 5850000 | 0 | 5850000 | 0 | 5850000.0 | 5850000 | Funcionamiento | 0 | Mujer | 0 | 0 | 5850000 | False | True | False | False | False | False | False | True |
| 221522 | San Andrés, Providencia y Santa Catalina | Territorial | Ejecutivo | Descentralizada | Cerrado | Contratación directa | 2022-02-01 | 2022-02-02 | 2022-07-02 | NaT | NaT | 17345800 | 0 | 17345800 | 0 | 17345800.0 | 17345800 | Inversión | 0 | No Definido | 0 | 17345800 | 0 | False | True | False | False | False | False | False | False |
| Departamento | Orden | Rama | Entidad Centralizada | Estado Contrato | Modalidad de Contratacion | Fecha de Firma | Fecha de Inicio del Contrato | Fecha de Fin del Contrato | Fecha de Inicio de Ejecucion | Fecha de Fin de Ejecucion | Valor del Contrato | Valor Facturado | Valor Pendiente de Pago | Valor Pagado | Valor Pendiente de Ejecucion | Saldo CDP | Destino Gasto | Dias Adicionados | Género Representante Legal | Presupuesto General de la Nacion – PGN | Recursos Propios (AlcaldÃas, Gobernaciones y Resguardos IndÃgenas) | Recursos Propios | EsServicioPublico | EsPrestacionServicios | EsGrupo | EsPyme | EstaLiquidado | EsObligacionAmbiental | Es PostConflicto | EsRecursosPropios | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2360668 | Santander | Territorial | Ejecutivo | Centralizada | terminado | Contratación directa | 2022-02-01 | 2022-02-15 | 2022-07-15 | NaT | NaT | 16500000 | 16500000 | 0 | 16500000 | 0.000000e+00 | 0 | Inversión | 0 | Hombre | 0 | 16500000 | 0 | True | True | False | False | False | False | False | False |
| 1226010 | Valle del Cauca | Territorial | Ejecutivo | Centralizada | Cerrado | Contratación directa | 2021-09-29 | 2021-10-07 | 2021-12-31 | NaT | NaT | 11039000 | 0 | 11039000 | 0 | 1.103900e+07 | 11039000 | Inversión | 0 | No Definido | 0 | 11039000 | 0 | False | True | False | False | False | False | False | False |
| 1747564 | Valle del Cauca | Territorial | Corporación Autónoma | Centralizada | Cerrado | Contratación directa | 2022-01-12 | 2022-01-17 | 2022-12-30 | NaT | NaT | 83820000 | 0 | 83820000 | 0 | 8.382000e+07 | 205198980 | Inversión | 0 | No Definido | 0 | 83820000 | 0 | False | True | False | False | False | False | False | False |
| 2560718 | Santander | Nacional | Ejecutivo | Descentralizada | terminado | Selección abreviada subasta inversa | 2022-04-19 | 2022-04-22 | 2022-12-10 | NaT | NaT | 30000000 | 29999481 | 29061601 | 938399 | 2.906160e+07 | 394172714 | Inversión | 0 | No Definido | 30000000 | 0 | 0 | False | False | False | True | True | True | False | False |
| 958926 | Distrito Capital de Bogotá | Nacional | Ejecutivo | Centralizada | terminado | Selección abreviada subasta inversa | 2019-06-06 | 2019-05-24 | 2019-07-23 | 2019-05-24 | 2019-07-23 | 1094343716 | 0 | 1094343716 | 0 | 1.094344e+09 | 5566918326 | Funcionamiento | 0 | No Definido | 0 | 0 | 0 | False | False | False | True | True | False | False | False |
| 167487 | Distrito Capital de Bogotá | Territorial | Ejecutivo | Descentralizada | terminado | Contratación régimen especial | 2021-01-27 | 2021-02-01 | 2021-07-31 | NaT | NaT | 13880128 | 0 | 13880128 | 0 | 1.388013e+07 | 25654978463 | Funcionamiento | 0 | No Definido | 0 | 13880128 | 0 | False | True | False | False | False | False | False | False |
| 2291911 | Distrito Capital de Bogotá | Territorial | Ejecutivo | Centralizada | cedido | Contratación directa | 2022-01-26 | 2022-01-28 | 2023-01-27 | NaT | NaT | 48000000 | 0 | 48000000 | 0 | 4.800000e+07 | 48000000 | Inversión | 0 | Mujer | 0 | 48000000 | 0 | False | True | False | False | False | False | False | False |
| 2383512 | Cesar | Nacional | Ejecutivo | Centralizada | terminado | Contratación régimen especial | 2020-02-18 | 2020-02-18 | 2020-12-31 | NaT | NaT | 1328564519 | 0 | 1328564519 | 0 | 1.328565e+09 | 1184822614 | Inversión | 0 | No Definido | 0 | 0 | 0 | False | False | False | False | False | False | False | False |
| 81157 | Boyacá | Nacional | Ejecutivo | Descentralizada | terminado | Contratación directa | 2021-02-17 | 2021-02-18 | 2021-12-10 | NaT | NaT | 36351534 | 36351534 | 0 | 36351534 | 0.000000e+00 | 1263021000 | Inversión | 0 | No Definido | 36351534 | 0 | 0 | False | True | False | False | False | False | False | False |
| 2672506 | Norte de Santander | Territorial | Ejecutivo | Centralizada | terminado | Contratación directa | 2020-09-07 | 2020-09-08 | 2020-12-24 | NaT | NaT | 10675000 | 10675000 | 0 | 10675000 | 0.000000e+00 | 10675000 | Funcionamiento | 0 | No Definido | 0 | 10675000 | 0 | False | True | False | False | False | False | False | False |
Most frequently occurring
| Departamento | Orden | Rama | Entidad Centralizada | Estado Contrato | Modalidad de Contratacion | Fecha de Firma | Fecha de Inicio del Contrato | Fecha de Fin del Contrato | Fecha de Inicio de Ejecucion | Fecha de Fin de Ejecucion | Valor del Contrato | Valor Facturado | Valor Pendiente de Pago | Valor Pagado | Valor Pendiente de Ejecucion | Saldo CDP | Destino Gasto | Dias Adicionados | Género Representante Legal | Presupuesto General de la Nacion – PGN | Recursos Propios (AlcaldÃas, Gobernaciones y Resguardos IndÃgenas) | Recursos Propios | EsServicioPublico | EsPrestacionServicios | EsGrupo | EsPyme | EstaLiquidado | EsObligacionAmbiental | Es PostConflicto | EsRecursosPropios | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Valle del Cauca | Territorial | Ejecutivo | Centralizada | Cerrado | Contratación directa | 2021-01-25 | 2021-01-26 | 2021-06-30 | NaT | NaT | 33450000 | 0 | 33450000 | 0 | 33450000.0 | 33450000 | Inversión | 0 | No Definido | 0 | 33450000 | 0 | False | True | False | False | False | False | False | False | 2 |
| 1 | Valle del Cauca | Territorial | Ejecutivo | Descentralizada | Cerrado | Contratación directa | 2021-07-28 | 2021-07-29 | 2021-12-31 | NaT | NaT | 41910000 | 0 | 41910000 | 0 | 41910000.0 | 41910000 | Inversión | 0 | No Definido | 0 | 41910000 | 0 | False | True | False | False | False | False | False | False | 2 |